Tank

Entity Definition

Logical Name : Tank
Physical Name : LO_TNK

A kind of Location used to store a FuelItem that is measured & dispensed by one or more FuelingPoints

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
TankID (PK) A unique identifier for this Tank ID_TNK Identity integer
LocationID (FK) A unique system assigned identifier for the Location. ID_LCN Identity integer InventoryLocation(LO_LCN_INV)
TankDiameter The diameter of the tank QL_DMTR_TNK Quantity DECIMAL(9,3)
ShellCapacity The largest volume of product that a tank can hold. QV_CPC_SHL Quantity DECIMAL(9,3)
MaximumSafeFillCapacity The largest capacity that the tank safely holds, taking temperature effects into consideration. QV_CPC_MXM Quantity DECIMAL(9,3)
LowCapacity The volume to which a tank may be emptied without prumping vapour into the line. The amount of product that just reaches the entrance of the suction pipe. QV_CPC_LW Quantity DECIMAL(9,3)
HighLevelSetPoint The level at which the TankLevelGauge will set off the 'High Level Alarm'. QL_LV_HGH Quantity DECIMAL(9,3)
LowLevelSetPoint The level at which the TankLevelGuage will set off the 'Low Level Alarm' QL_LV_LW Quantity DECIMAL(9,3)
LowLowLevelSetPoint The level at which the TankLevelGuage will set off the 'Low Low Level Alarm' This alarm is the 'I really mean it this time, and you better do something real soon Low Level Alarm' QL_LV_LW_LW Quantity DECIMAL(9,3)
HighWaterSetPoint The level at which the TankLevelGuage will set off the 'High Water Alarm' QL_LV_WTR_HGH Quantity DECIMAL(9,3)
StrapLevel The Strap Level Height (a technical term) QL_LV_STRP Quantity DECIMAL(9,3)
StrapVolume The volume of product stored in the Tank when the height reading is equal to the StrapLevel QV_STRP Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
BusinessUnit houses Tank
InventoryLocation is a Tank
Tank has TankTemperatureSensor
Tank has TankProbe

Logical Views containing Tank

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20050 - Forecourt Tank Gauge View